Pandas Profiling Report

Dataset statistics

Number of variables	37
Number of observations	210721
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	57.7 MiB
Average record size in memory	287.0 B

Variable types

Numeric	23
Categorical	11
Boolean	3

Alerts

`age_is_na` has constant value "False"	Constant
`first_affiliate_tracked_is_na` has constant value "False"	Constant
`first_browser` has a high cardinality: 52 distinct values	High cardinality
`df_index` is highly correlated with `first_active_account_year` and 1 other fields	High correlation
`first_booking_day_of_week` is highly correlated with `first_booking_day` and 3 other fields	High correlation
`first_active_account_day_of_week` is highly correlated with `account_creation_day_of_week`	High correlation
`account_creation_day_of_week` is highly correlated with `first_active_account_day_of_week`	High correlation
`first_booking_day` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_day` is highly correlated with `account_creation_day`	High correlation
`account_creation_day` is highly correlated with `first_active_account_day`	High correlation
`first_booking_month` is highly correlated with `first_booking_day_of_year` and 1 other fields	High correlation
`first_active_account_month` is highly correlated with `account_creation_month` and 4 other fields	High correlation
`account_creation_month` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_year` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_year` is highly correlated with `df_index` and 1 other fields	High correlation
`account_creation_year` is highly correlated with `df_index` and 1 other fields	High correlation
`first_booking_day_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_week_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`days_account_creation_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`days_first_active_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`df_index` is highly correlated with `first_active_account_year` and 1 other fields	High correlation
`first_booking_day_of_week` is highly correlated with `first_booking_day` and 3 other fields	High correlation
`first_active_account_day_of_week` is highly correlated with `account_creation_day_of_week`	High correlation
`account_creation_day_of_week` is highly correlated with `first_active_account_day_of_week`	High correlation
`first_booking_day` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_day` is highly correlated with `account_creation_day`	High correlation
`account_creation_day` is highly correlated with `first_active_account_day`	High correlation
`first_booking_month` is highly correlated with `first_booking_day_of_year` and 1 other fields	High correlation
`first_active_account_month` is highly correlated with `account_creation_month` and 4 other fields	High correlation
`account_creation_month` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_year` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_year` is highly correlated with `df_index` and 1 other fields	High correlation
`account_creation_year` is highly correlated with `df_index` and 1 other fields	High correlation
`first_booking_day_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_week_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`days_account_creation_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`days_first_active_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`df_index` is highly correlated with `first_active_account_year` and 1 other fields	High correlation
`first_booking_day_of_week` is highly correlated with `first_booking_day` and 3 other fields	High correlation
`first_active_account_day_of_week` is highly correlated with `account_creation_day_of_week`	High correlation
`account_creation_day_of_week` is highly correlated with `first_active_account_day_of_week`	High correlation
`first_booking_day` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_day` is highly correlated with `account_creation_day`	High correlation
`account_creation_day` is highly correlated with `first_active_account_day`	High correlation
`first_booking_month` is highly correlated with `first_booking_day_of_year` and 1 other fields	High correlation
`first_active_account_month` is highly correlated with `account_creation_month` and 4 other fields	High correlation
`account_creation_month` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_year` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_active_account_year` is highly correlated with `df_index` and 1 other fields	High correlation
`account_creation_year` is highly correlated with `df_index` and 1 other fields	High correlation
`first_booking_day_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_day_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`first_booking_week_of_year` is highly correlated with `first_booking_month` and 1 other fields	High correlation
`first_active_account_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`account_creation_week_of_year` is highly correlated with `first_active_account_month` and 4 other fields	High correlation
`days_account_creation_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`days_first_active_first_booking` is highly correlated with `first_booking_day_of_week` and 3 other fields	High correlation
`first_device_type` is highly correlated with `first_browser` and 3 other fields	High correlation
`first_browser` is highly correlated with `first_device_type` and 2 other fields	High correlation
`age_is_na` is highly correlated with `first_device_type` and 12 other fields	High correlation
`signup_method` is highly correlated with `age_is_na` and 1 other fields	High correlation
`affiliate_channel` is highly correlated with `age_is_na` and 2 other fields	High correlation
`language` is highly correlated with `age_is_na` and 1 other fields	High correlation
`country_destination` is highly correlated with `age_is_na` and 2 other fields	High correlation
`first_affiliate_tracked_is_na` is highly correlated with `first_device_type` and 12 other fields	High correlation
`gender` is highly correlated with `age_is_na` and 1 other fields	High correlation
`affiliate_provider` is highly correlated with `age_is_na` and 2 other fields	High correlation
`account_creation_year` is highly correlated with `age_is_na` and 1 other fields	High correlation
`signup_app` is highly correlated with `first_device_type` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `age_is_na` and 1 other fields	High correlation
`date_first_booking_is_na` is highly correlated with `age_is_na` and 2 other fields	High correlation
`df_index` is highly correlated with `first_booking_month` and 13 other fields	High correlation
`gender` is highly correlated with `age`	High correlation
`age` is highly correlated with `gender`	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 4 other fields	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 2 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`country_destination` is highly correlated with `date_first_booking_is_na` and 8 other fields	High correlation
`date_first_booking_is_na` is highly correlated with `country_destination` and 8 other fields	High correlation
`first_booking_day_of_week` is highly correlated with `country_destination` and 8 other fields	High correlation
`first_active_account_day_of_week` is highly correlated with `account_creation_day_of_week`	High correlation
`account_creation_day_of_week` is highly correlated with `first_active_account_day_of_week`	High correlation
`first_booking_day` is highly correlated with `country_destination` and 10 other fields	High correlation
`first_active_account_day` is highly correlated with `first_booking_day` and 1 other fields	High correlation
`account_creation_day` is highly correlated with `first_booking_day` and 1 other fields	High correlation
`first_booking_month` is highly correlated with `df_index` and 15 other fields	High correlation
`first_active_account_month` is highly correlated with `df_index` and 12 other fields	High correlation
`account_creation_month` is highly correlated with `df_index` and 12 other fields	High correlation
`first_booking_year` is highly correlated with `df_index` and 11 other fields	High correlation
`first_active_account_year` is highly correlated with `df_index` and 10 other fields	High correlation
`account_creation_year` is highly correlated with `df_index` and 10 other fields	High correlation
`first_booking_day_of_year` is highly correlated with `df_index` and 15 other fields	High correlation
`first_active_account_day_of_year` is highly correlated with `df_index` and 12 other fields	High correlation
`account_creation_day_of_year` is highly correlated with `df_index` and 12 other fields	High correlation
`first_booking_week_of_year` is highly correlated with `df_index` and 15 other fields	High correlation
`first_active_account_week_of_year` is highly correlated with `df_index` and 12 other fields	High correlation
`account_creation_week_of_year` is highly correlated with `df_index` and 12 other fields	High correlation
`days_account_creation_first_booking` is highly correlated with `df_index` and 17 other fields	High correlation
`days_first_active_first_booking` is highly correlated with `df_index` and 17 other fields	High correlation
`days_first_active_acount_creation` is highly skewed (γ1 = -74.02857652)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`signup_flow` has 162507 (77.1%) zeros	Zeros
`first_booking_day_of_week` has 135773 (64.4%) zeros	Zeros
`first_active_account_day_of_week` has 32472 (15.4%) zeros	Zeros
`account_creation_day_of_week` has 32469 (15.4%) zeros	Zeros
`days_account_creation_first_booking` has 21074 (10.0%) zeros	Zeros
`days_first_active_acount_creation` has 210574 (99.9%) zeros	Zeros
`days_first_active_first_booking` has 14516 (6.9%) zeros	Zeros

Reproduction

Analysis started	2022-02-01 16:26:04.042909
Analysis finished	2022-02-01 16:27:20.184590
Duration	1 minute and 16.14 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	210721
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106869.7705

Minimum	0
Maximum	213450
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	10757
Q1	53508
median	106930
Q3	160245
95-th percentile	202832
Maximum	213450
Range	213450
Interquartile range (IQR)	106737

Descriptive statistics

Standard deviation	61611.551
Coefficient of variation (CV)	0.576510558
Kurtosis	-1.200067066
Mean	106869.7705
Median Absolute Deviation (MAD)	53369
Skewness	-0.001846801687
Sum	2.25197049 × 10¹⁰
Variance	3795983217
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
142459	1	< 0.1%
142449	1	< 0.1%
142450	1	< 0.1%
142451	1	< 0.1%
142452	1	< 0.1%
142453	1	< 0.1%
142454	1	< 0.1%
142455	1	< 0.1%
142456	1	< 0.1%
Other values (210711)	210711	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
213450	1	< 0.1%
213449	1	< 0.1%
213448	1	< 0.1%
213447	1	< 0.1%
213446	1	< 0.1%
213445	1	< 0.1%
213444	1	< 0.1%
213443	1	< 0.1%
213442	1	< 0.1%
213441	1	< 0.1%

gender
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

-unknown-	94949
FEMALE	61895
MALE	53599
OTHER	278

Length

Max length	9
Median length	6
Mean length	6.841733857
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-unknown-
2nd row	MALE
3rd row	FEMALE
4th row	-unknown-
5th row	FEMALE

Common Values

Value	Count	Frequency (%)
-unknown-	94949	45.1%
FEMALE	61895	29.4%
MALE	53599	25.4%
OTHER	278	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unknown	94949	45.1%
female	61895	29.4%
male	53599	25.4%
other	278	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	73
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.44355807

Minimum	18
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	18
5-th percentile	24
Q1	32
median	34
Q3	35
95-th percentile	55
Maximum	90
Range	72
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	8.820051231
Coefficient of variation (CV)	0.2488477938
Kurtosis	4.646812788
Mean	35.44355807
Median Absolute Deviation (MAD)	2
Skewness	1.802229067
Sum	7468702
Variance	77.79330371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34	93015	44.1%
30	6123	2.9%
31	6016	2.9%
29	5963	2.8%
28	5939	2.8%
32	5855	2.8%
27	5738	2.7%
33	5526	2.6%
26	5044	2.4%
35	4858	2.3%
Other values (63)	66644	31.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	669	0.3%
19	1102	0.5%
20	540	0.3%
21	982	0.5%
22	1702	0.8%
23	2462	1.2%
24	3220	1.5%
25	4458	2.1%
26	5044	2.4%
27	5738	2.7%

Value	Count	Frequency (%)
90	18	< 0.1%
89	13	< 0.1%
88	12	< 0.1%
87	31	< 0.1%
86	27	< 0.1%
85	26	< 0.1%
84	20	< 0.1%
83	25	< 0.1%
82	26	< 0.1%
81	30	< 0.1%

signup_method
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

basic	150954
facebook	59222
google	545

Length

Max length	8
Median length	5
Mean length	5.84572017
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	facebook
3rd row	facebook
4th row	basic
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	150954	71.6%
facebook	59222	28.1%
google	545	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
basic	150954	71.6%
facebook	59222	28.1%
google	545	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.285021426

Minimum	0
Maximum	25
Zeros	162507
Zeros (%)	77.1%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	25
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.657414612
Coefficient of variation (CV)	2.331009031
Kurtosis	3.278878961
Mean	3.285021426
Median Absolute Deviation (MAD)	0
Skewness	2.224659025
Sum	692223
Variance	58.63599854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	162507	77.1%
25	14579	6.9%
12	9248	4.4%
3	8718	4.1%
2	6744	3.2%
24	4283	2.0%
23	2819	1.3%
1	1026	0.5%
6	296	0.1%
8	238	0.1%
Other values (7)	263	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	162507	77.1%
1	1026	0.5%
2	6744	3.2%
3	8718	4.1%
4	1	< 0.1%
5	35	< 0.1%
6	296	0.1%
8	238	0.1%
10	2	< 0.1%
12	9248	4.4%

Value	Count	Frequency (%)
25	14579	6.9%
24	4283	2.0%
23	2819	1.3%
21	190	0.1%
20	14	< 0.1%
16	11	< 0.1%
15	10	< 0.1%
12	9248	4.4%
10	2	< 0.1%
8	238	0.1%

language
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

en	203692
zh	1623
fr	1136
es	902
ko	738
Other values (20)	2630

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	203692	96.7%
zh	1623	0.8%
fr	1136	0.5%
es	902	0.4%
ko	738	0.4%
de	728	0.3%
it	503	0.2%
ru	379	0.2%
pt	235	0.1%
ja	223	0.1%
Other values (15)	562	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	203692	96.7%
zh	1623	0.8%
fr	1136	0.5%
es	902	0.4%
ko	738	0.4%
de	728	0.3%
it	503	0.2%
ru	379	0.2%
pt	235	0.1%
ja	223	0.1%
Other values (15)	562	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

direct	136034
sem-brand	25679
sem-non-brand	18582
other	8810
seo	8542
Other values (3)	13074

Length

Max length	13
Median length	6
Mean length	6.748311749
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	direct
2nd row	seo
3rd row	direct
4th row	other
5th row	other

Common Values

Value	Count	Frequency (%)
direct	136034	64.6%
sem-brand	25679	12.2%
sem-non-brand	18582	8.8%
other	8810	4.2%
seo	8542	4.1%
api	8095	3.8%
content	3900	1.9%
remarketing	1079	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
direct	136034	64.6%
sem-brand	25679	12.2%
sem-non-brand	18582	8.8%
other	8810	4.2%
seo	8542	4.1%
api	8095	3.8%
content	3900	1.9%
remarketing	1079	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

direct	135738
google	50957
other	12400
craigslist	3406
bing	2299
Other values (13)	5921

Length

Max length	19
Median length	6
Mean length	6.039331628
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	direct
2nd row	google
3rd row	direct
4th row	other
5th row	craigslist

Common Values

Value	Count	Frequency (%)
direct	135738	64.4%
google	50957	24.2%
other	12400	5.9%
craigslist	3406	1.6%
bing	2299	1.1%
facebook	2253	1.1%
vast	821	0.4%
padmapper	757	0.4%
facebook-open-graph	538	0.3%
yahoo	491	0.2%
Other values (8)	1061	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	135738	64.4%
google	50957	24.2%
other	12400	5.9%
craigslist	3406	1.6%
bing	2299	1.1%
facebook	2253	1.1%
vast	821	0.4%
padmapper	757	0.4%
facebook-open-graph	538	0.3%
yahoo	491	0.2%
Other values (8)	1061	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_affiliate_tracked
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

untracked	107916
linked	45648
omg	43421
tracked-other	6045
unknown	5990
Other values (3)	1701

Length

Max length	13
Median length	9
Mean length	7.157146179
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	omg
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	107916	51.2%
linked	45648	21.7%
omg	43421	20.6%
tracked-other	6045	2.9%
unknown	5990	2.8%
product	1529	0.7%
marketing	139	0.1%
local ops	33	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
untracked	107916	51.2%
linked	45648	21.7%
omg	43421	20.6%
tracked-other	6045	2.9%
unknown	5990	2.8%
product	1529	0.7%
marketing	139	0.1%
local	33	< 0.1%
ops	33	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Web	180206
iOS	18898
Moweb	6193
Android	5424

Length

Max length	7
Median length	3
Mean length	3.161739931
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	180206	85.5%
iOS	18898	9.0%
Moweb	6193	2.9%
Android	5424	2.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
web	180206	85.5%
ios	18898	9.0%
moweb	6193	2.9%
android	5424	2.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Mac Desktop	88350
Windows Desktop	71737
iPhone	20601
iPad	14170
Other/Unknown	10560
Other values (4)	5303

Length

Max length	18
Median length	11
Mean length	11.57179873
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Mac Desktop
3rd row	Mac Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	88350	41.9%
Windows Desktop	71737	34.0%
iPhone	20601	9.8%
iPad	14170	6.7%
Other/Unknown	10560	5.0%
Android Phone	2775	1.3%
Android Tablet	1270	0.6%
Desktop (Other)	1183	0.6%
SmartPhone (Other)	75	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
desktop	161270	42.9%
mac	88350	23.5%
windows	71737	19.1%
iphone	20601	5.5%
ipad	14170	3.8%
other/unknown	10560	2.8%
android	4045	1.1%
phone	2775	0.7%
tablet	1270	0.3%
other	1258	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_browser
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Chrome	63045
Safari	44502
Firefox	33186
-unknown-	27056
IE	20760
Other values (47)	22172

Length

Max length	20
Median length	6
Mean length	6.87365284
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	Chrome
3rd row	Firefox
4th row	Chrome
5th row	Safari

Common Values

Value	Count	Frequency (%)
Chrome	63045	29.9%
Safari	44502	21.1%
Firefox	33186	15.7%
-unknown-	27056	12.8%
IE	20760	9.9%
Mobile Safari	19053	9.0%
Chrome Mobile	1251	0.6%
Android Browser	838	0.4%
AOL Explorer	238	0.1%
Opera	183	0.1%
Other values (42)	609	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	64296	27.7%
safari	63555	27.4%
firefox	33215	14.3%
unknown	27056	11.6%
ie	20796	9.0%
mobile	20371	8.8%
browser	901	0.4%
android	838	0.4%
explorer	271	0.1%
aol	238	0.1%
Other values (48)	786	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

country_destination
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

NDF	123233
US	61382
other	9920
FR	4960
IT	2783
Other values (7)	8443

Length

Max length	5
Median length	3
Mean length	2.72604534
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	NDF
3rd row	other
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	123233	58.5%
US	61382	29.1%
other	9920	4.7%
FR	4960	2.4%
IT	2783	1.3%
GB	2284	1.1%
ES	2218	1.1%
CA	1404	0.7%
DE	1042	0.5%
NL	750	0.4%
Other values (2)	745	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	123233	58.5%
us	61382	29.1%
other	9920	4.7%
fr	4960	2.4%
it	2783	1.3%
gb	2284	1.1%
es	2218	1.1%
ca	1404	0.7%
de	1042	0.5%
nl	750	0.4%
Other values (2)	745	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

date_first_booking_is_na
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	205.9 KiB

True	123233
False	87488

Common Values
Chart

Value	Count	Frequency (%)
True	123233	58.5%
False	87488	41.5%

age_is_na
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	205.9 KiB

False	210721

Common Values
Chart

Value	Count	Frequency (%)
False	210721	100.0%

first_affiliate_tracked_is_na
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	205.9 KiB

False	210721

Common Values
Chart

Value	Count	Frequency (%)
False	210721	100.0%

first_booking_day_of_week
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.163562246

Minimum	0
Maximum	6
Zeros	135773
Zeros (%)	64.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.852311685
Coefficient of variation (CV)	1.591931752
Kurtosis	0.539268494
Mean	1.163562246
Median Absolute Deviation (MAD)	0
Skewness	1.383228706
Sum	245187
Variance	3.431058578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	135773	64.4%
2	14177	6.7%
1	14060	6.7%
3	13702	6.5%
4	13065	6.2%
5	10257	4.9%
6	9687	4.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	135773	64.4%
1	14060	6.7%
2	14177	6.7%
3	13702	6.5%
4	13065	6.2%
5	10257	4.9%
6	9687	4.6%

Value	Count	Frequency (%)
6	9687	4.6%
5	10257	4.9%
4	13065	6.2%
3	13702	6.5%
2	14177	6.7%
1	14060	6.7%
0	135773	64.4%

first_active_account_day_of_week
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.763407539

Minimum	0
Maximum	6
Zeros	32472
Zeros (%)	15.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.944705547
Coefficient of variation (CV)	0.7037346173
Kurtosis	-1.150393083
Mean	2.763407539
Median Absolute Deviation (MAD)	2
Skewness	0.1668700811
Sum	582308
Variance	3.781879664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	34612	16.4%
2	33687	16.0%
0	32472	15.4%
3	32163	15.3%
4	29346	13.9%
6	24244	11.5%
5	24197	11.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	32472	15.4%
1	34612	16.4%
2	33687	16.0%
3	32163	15.3%
4	29346	13.9%
5	24197	11.5%
6	24244	11.5%

Value	Count	Frequency (%)
6	24244	11.5%
5	24197	11.5%
4	29346	13.9%
3	32163	15.3%
2	33687	16.0%
1	34612	16.4%
0	32472	15.4%

account_creation_day_of_week
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.763450249

Minimum	0
Maximum	6
Zeros	32469
Zeros (%)	15.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.944704642
Coefficient of variation (CV)	0.7037234133
Kurtosis	-1.150420741
Mean	2.763450249
Median Absolute Deviation (MAD)	2
Skewness	0.1668553777
Sum	582317
Variance	3.781876144
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	34615	16.4%
2	33687	16.0%
0	32469	15.4%
3	32158	15.3%
4	29351	13.9%
6	24245	11.5%
5	24196	11.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	32469	15.4%
1	34615	16.4%
2	33687	16.0%
3	32158	15.3%
4	29351	13.9%
5	24196	11.5%
6	24245	11.5%

Value	Count	Frequency (%)
6	24245	11.5%
5	24196	11.5%
4	29351	13.9%
3	32158	15.3%
2	33687	16.0%
1	34615	16.4%
0	32469	15.4%

first_booking_day
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.45567362

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	19
median	29
Q3	29
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.655450281
Coefficient of variation (CV)	0.3690130764
Kurtosis	0.1812988587
Mean	23.45567362
Median Absolute Deviation (MAD)	0
Skewness	-1.283625481
Sum	4942603
Variance	74.91681957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	125816	59.7%
10	3046	1.4%
17	3016	1.4%
11	2999	1.4%
13	2973	1.4%
16	2971	1.4%
15	2968	1.4%
5	2942	1.4%
3	2913	1.4%
6	2909	1.4%
Other values (21)	58168	27.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2720	1.3%
2	2828	1.3%
3	2913	1.4%
4	2815	1.3%
5	2942	1.4%
6	2909	1.4%
7	2881	1.4%
8	2901	1.4%
9	2873	1.4%
10	3046	1.4%

Value	Count	Frequency (%)
31	1535	0.7%
30	2660	1.3%
29	125816	59.7%
28	2839	1.3%
27	2722	1.3%
26	2777	1.3%
25	2835	1.3%
24	2842	1.3%
23	2808	1.3%
22	2899	1.4%

first_active_account_day
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.87166443

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.740370127
Coefficient of variation (CV)	0.5506902043
Kurtosis	-1.186209018
Mean	15.87166443
Median Absolute Deviation (MAD)	8
Skewness	-0.01164470356
Sum	3344493
Variance	76.39406996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	7317	3.5%
16	7162	3.4%
18	7160	3.4%
20	7130	3.4%
23	7122	3.4%
19	7109	3.4%
28	7056	3.3%
26	7038	3.3%
13	7037	3.3%
17	7035	3.3%
Other values (21)	139555	66.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6125	2.9%
2	6707	3.2%
3	6853	3.3%
4	6748	3.2%
5	6932	3.3%
6	6875	3.3%
7	6648	3.2%
8	6827	3.2%
9	6832	3.2%
10	6941	3.3%

Value	Count	Frequency (%)
31	3695	1.8%
30	6675	3.2%
29	6485	3.1%
28	7056	3.3%
27	6979	3.3%
26	7038	3.3%
25	6877	3.3%
24	7317	3.5%
23	7122	3.4%
22	6866	3.3%

account_creation_day
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.87128478

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.740640362
Coefficient of variation (CV)	0.5507204037
Kurtosis	-1.186274197
Mean	15.87128478
Median Absolute Deviation (MAD)	8
Skewness	-0.01166694181
Sum	3344413
Variance	76.39879393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	7318	3.5%
16	7168	3.4%
18	7160	3.4%
20	7131	3.4%
23	7121	3.4%
19	7105	3.4%
28	7059	3.3%
26	7035	3.3%
13	7033	3.3%
17	7033	3.3%
Other values (21)	139558	66.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6126	2.9%
2	6709	3.2%
3	6858	3.3%
4	6747	3.2%
5	6934	3.3%
6	6874	3.3%
7	6646	3.2%
8	6830	3.2%
9	6831	3.2%
10	6939	3.3%

Value	Count	Frequency (%)
31	3693	1.8%
30	6675	3.2%
29	6487	3.1%
28	7059	3.3%
27	6977	3.3%
26	7035	3.3%
25	6874	3.3%
24	7318	3.5%
23	7121	3.4%
22	6872	3.3%

first_booking_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.047356457

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	6
Q3	6
95-th percentile	10
Maximum	12
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.04984678
Coefficient of variation (CV)	0.3389657604
Kurtosis	1.918530764
Mean	6.047356457
Median Absolute Deviation (MAD)	0
Skewness	0.3903313435
Sum	1274305
Variance	4.20187182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	133595	63.4%
5	10328	4.9%
4	8667	4.1%
3	8249	3.9%
7	7141	3.4%
8	6938	3.3%
2	6653	3.2%
9	6482	3.1%
1	6372	3.0%
10	6094	2.9%
Other values (2)	10202	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6372	3.0%
2	6653	3.2%
3	8249	3.9%
4	8667	4.1%
5	10328	4.9%
6	133595	63.4%
7	7141	3.4%
8	6938	3.3%
9	6482	3.1%
10	6094	2.9%

Value	Count	Frequency (%)
12	5011	2.4%
11	5191	2.5%
10	6094	2.9%
9	6482	3.1%
8	6938	3.3%
7	7141	3.4%
6	133595	63.4%
5	10328	4.9%
4	8667	4.1%
3	8249	3.9%

first_active_account_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.023153838

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.236360926
Coefficient of variation (CV)	0.5373199843
Kurtosis	-0.9694602136
Mean	6.023153838
Median Absolute Deviation (MAD)	3
Skewness	0.2485199619
Sum	1269205
Variance	10.47403204
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	27129	12.9%
5	25601	12.1%
4	21603	10.3%
3	20060	9.5%
1	17261	8.2%
2	16336	7.8%
9	15181	7.2%
8	14395	6.8%
7	13627	6.5%
10	13323	6.3%
Other values (2)	26205	12.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	17261	8.2%
2	16336	7.8%
3	20060	9.5%
4	21603	10.3%
5	25601	12.1%
6	27129	12.9%
7	13627	6.5%
8	14395	6.8%
9	15181	7.2%
10	13323	6.3%

Value	Count	Frequency (%)
12	13238	6.3%
11	12967	6.2%
10	13323	6.3%
9	15181	7.2%
8	14395	6.8%
7	13627	6.5%
6	27129	12.9%
5	25601	12.1%
4	21603	10.3%
3	20060	9.5%

account_creation_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.02316333

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.236538282
Coefficient of variation (CV)	0.5373485832
Kurtosis	-0.9695745673
Mean	6.02316333
Median Absolute Deviation (MAD)	3
Skewness	0.2484757975
Sum	1269207
Variance	10.47518005
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	27128	12.9%
5	25604	12.2%
4	21595	10.2%
3	20059	9.5%
1	17266	8.2%
2	16338	7.8%
9	15186	7.2%
8	14392	6.8%
7	13623	6.5%
10	13323	6.3%
Other values (2)	26207	12.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	17266	8.2%
2	16338	7.8%
3	20059	9.5%
4	21595	10.2%
5	25604	12.2%
6	27128	12.9%
7	13623	6.5%
8	14392	6.8%
9	15186	7.2%
10	13323	6.3%

Value	Count	Frequency (%)
12	13242	6.3%
11	12965	6.2%
10	13323	6.3%
9	15186	7.2%
8	14392	6.8%
7	13623	6.5%
6	27128	12.9%
5	25604	12.2%
4	21595	10.2%
3	20059	9.5%

first_booking_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.187585

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	2010
5-th percentile	2012
Q1	2013
median	2015
Q3	2015
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.165490157
Coefficient of variation (CV)	0.0005786403242
Kurtosis	0.8803769206
Mean	2014.187585
Median Absolute Deviation (MAD)	0
Skewness	-1.322180239
Sum	424431622
Variance	1.358367306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2015	124980	59.3%
2014	31925	15.2%
2013	30712	14.6%
2012	16013	7.6%
2011	5650	2.7%
2010	1441	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010	1441	0.7%
2011	5650	2.7%
2012	16013	7.6%
2013	30712	14.6%
2014	31925	15.2%
2015	124980	59.3%

Value	Count	Frequency (%)
2015	124980	59.3%
2014	31925	15.2%
2013	30712	14.6%
2012	16013	7.6%
2011	5650	2.7%
2010	1441	0.7%

first_active_account_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.02537

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9375234033
Coefficient of variation (CV)	0.0004657285583
Kurtosis	0.2805745293
Mean	2013.02537
Median Absolute Deviation (MAD)	1
Skewness	-0.8265063759
Sum	424186719
Variance	0.8789501318
Monotonicity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	81880	38.9%
2014	75606	35.9%
2012	38923	18.5%
2011	11602	5.5%
2010	2707	1.3%
2009	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	3	< 0.1%
2010	2707	1.3%
2011	11602	5.5%
2012	38923	18.5%
2013	81880	38.9%
2014	75606	35.9%

Value	Count	Frequency (%)
2014	75606	35.9%
2013	81880	38.9%
2012	38923	18.5%
2011	11602	5.5%
2010	2707	1.3%
2009	3	< 0.1%

account_creation_year
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

2013	81890
2014	75642
2012	38905
2011	11582
2010	2702

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2010
2nd row	2011
3rd row	2011
4th row	2010
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	81890	38.9%
2014	75642	35.9%
2012	38905	18.5%
2011	11582	5.5%
2010	2702	1.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2013	81890	38.9%
2014	75642	35.9%
2012	38905	18.5%
2011	11582	5.5%
2010	2702	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_booking_day_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	366
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	176.0442623

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	50
Q1	180
median	180
Q3	180
95-th percentile	303
Maximum	366
Range	365
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	62.68708613
Coefficient of variation (CV)	0.3560870733
Kurtosis	1.777671783
Mean	176.0442623
Median Absolute Deviation (MAD)	0
Skewness	0.04137439194
Sum	37096223
Variance	3929.670768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	123533	58.6%
162	410	0.2%
142	410	0.2%
141	407	0.2%
176	401	0.2%
134	394	0.2%
164	384	0.2%
170	382	0.2%
157	379	0.2%
161	375	0.2%
Other values (356)	83646	39.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	86	< 0.1%
2	145	0.1%
3	192	0.1%
4	181	0.1%
5	170	0.1%
6	187	0.1%
7	218	0.1%
8	173	0.1%
9	209	0.1%
10	234	0.1%

Value	Count	Frequency (%)
366	35	< 0.1%
365	165	0.1%
364	161	0.1%
363	141	0.1%
362	156	0.1%
361	151	0.1%
360	101	< 0.1%
359	118	0.1%
358	108	0.1%
357	142	0.1%

first_active_account_day_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	366
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	167.9508402

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	89
median	157
Q3	248
95-th percentile	341
Maximum	366
Range	365
Interquartile range (IQR)	159

Descriptive statistics

Standard deviation	98.82570567
Coefficient of variation (CV)	0.5884204303
Kurtosis	-0.9640146458
Mean	167.9508402
Median Absolute Deviation (MAD)	78
Skewness	0.2556678312
Sum	35390769
Variance	9766.520101
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
175	1049	0.5%
176	1041	0.5%
178	1009	0.5%
177	1004	0.5%
133	1001	0.5%
134	989	0.5%
154	986	0.5%
170	983	0.5%
162	972	0.5%
141	966	0.5%
Other values (356)	200721	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	257	0.1%
2	524	0.2%
3	565	0.3%
4	474	0.2%
5	496	0.2%
6	524	0.2%
7	564	0.3%
8	578	0.3%
9	650	0.3%
10	612	0.3%

Value	Count	Frequency (%)
366	99	< 0.1%
365	409	0.2%
364	500	0.2%
363	440	0.2%
362	501	0.2%
361	455	0.2%
360	355	0.2%
359	251	0.1%
358	317	0.2%
357	380	0.2%

account_creation_day_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	366
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	167.9507548

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	89
median	157
Q3	248
95-th percentile	341
Maximum	366
Range	365
Interquartile range (IQR)	159

Descriptive statistics

Standard deviation	98.83110853
Coefficient of variation (CV)	0.5884528989
Kurtosis	-0.964153136
Mean	167.9507548
Median Absolute Deviation (MAD)	78
Skewness	0.2556023476
Sum	35390751
Variance	9767.588012
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
175	1049	0.5%
176	1042	0.5%
178	1008	0.5%
177	1003	0.5%
133	1001	0.5%
134	989	0.5%
154	986	0.5%
170	983	0.5%
162	973	0.5%
141	965	0.5%
Other values (356)	200722	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	256	0.1%
2	523	0.2%
3	568	0.3%
4	474	0.2%
5	497	0.2%
6	524	0.2%
7	564	0.3%
8	579	0.3%
9	649	0.3%
10	613	0.3%

Value	Count	Frequency (%)
366	98	< 0.1%
365	409	0.2%
364	500	0.2%
363	440	0.2%
362	502	0.2%
361	455	0.2%
360	355	0.2%
359	250	0.1%
358	317	0.2%
357	380	0.2%

first_booking_week_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.0757542

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	27
median	27
Q3	27
95-th percentile	44
Maximum	53
Range	52
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.943092287
Coefficient of variation (CV)	0.3429658149
Kurtosis	1.711245047
Mean	26.0757542
Median Absolute Deviation (MAD)	0
Skewness	-0.1392491066
Sum	5494709
Variance	79.97889966
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	125057	59.3%
26	2499	1.2%
24	2469	1.2%
21	2446	1.2%
20	2420	1.1%
25	2393	1.1%
23	2379	1.1%
18	2289	1.1%
19	2276	1.1%
22	2219	1.1%
Other values (43)	64274	30.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1098	0.5%
2	1444	0.7%
3	1723	0.8%
4	1411	0.7%
5	1458	0.7%
6	1592	0.8%
7	1719	0.8%
8	1692	0.8%
9	1762	0.8%
10	1849	0.9%

Value	Count	Frequency (%)
53	1	< 0.1%
52	932	0.4%
51	1150	0.5%
50	1184	0.6%
49	1262	0.6%
48	1139	0.5%
47	1137	0.5%
46	1213	0.6%
45	1372	0.7%
44	1209	0.6%

first_active_account_week_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.39574129

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.01829598
Coefficient of variation (CV)	0.5746206198
Kurtosis	-0.9570199261
Mean	24.39574129
Median Absolute Deviation (MAD)	11
Skewness	0.2497096149
Sum	5140695
Variance	196.5126221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	6803	3.2%
25	6445	3.1%
24	6183	2.9%
21	6121	2.9%
23	6073	2.9%
20	6070	2.9%
22	5654	2.7%
19	5511	2.6%
18	5449	2.6%
17	5364	2.5%
Other values (43)	151048	71.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3292	1.6%
2	3946	1.9%
3	4145	2.0%
4	3911	1.9%
5	3884	1.8%
6	4015	1.9%
7	3973	1.9%
8	4170	2.0%
9	4405	2.1%
10	4363	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	2777	1.3%
51	2863	1.4%
50	2984	1.4%
49	3267	1.6%
48	2941	1.4%
47	3015	1.4%
46	3190	1.5%
45	3116	1.5%
44	2818	1.3%

account_creation_week_of_year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.39557519

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.01901207
Coefficient of variation (CV)	0.5746538855
Kurtosis	-0.9571391421
Mean	24.39557519
Median Absolute Deviation (MAD)	11
Skewness	0.2496500729
Sum	5140660
Variance	196.5326995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	6802	3.2%
25	6446	3.1%
24	6184	2.9%
21	6120	2.9%
23	6072	2.9%
20	6069	2.9%
22	5658	2.7%
19	5508	2.6%
18	5455	2.6%
17	5362	2.5%
Other values (43)	151045	71.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3295	1.6%
2	3948	1.9%
3	4145	2.0%
4	3910	1.9%
5	3885	1.8%
6	4015	1.9%
7	3976	1.9%
8	4170	2.0%
9	4405	2.1%
10	4363	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	2776	1.3%
51	2863	1.4%
50	2985	1.4%
49	3270	1.6%
48	2940	1.4%
47	3018	1.4%
46	3186	1.5%
45	3117	1.5%
44	2818	1.3%

days_account_creation_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1967
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	432.234979

Minimum	0
Maximum	2001
Zeros	21074
Zeros (%)	10.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	421
Q3	687
95-th percentile	1148
Maximum	2001
Range	2001
Interquartile range (IQR)	681

Descriptive statistics

Standard deviation	400.3373087
Coefficient of variation (CV)	0.926202941
Kurtosis	-0.1184298914
Mean	432.234979
Median Absolute Deviation (MAD)	380
Skewness	0.6753168766
Sum	91080987
Variance	160269.9608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21074	10.0%
1	14521	6.9%
2	6399	3.0%
3	3955	1.9%
4	2888	1.4%
5	2226	1.1%
6	1758	0.8%
7	1638	0.8%
8	1290	0.6%
9	1032	0.5%
Other values (1957)	153940	73.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21074	10.0%
1	14521	6.9%
2	6399	3.0%
3	3955	1.9%
4	2888	1.4%
5	2226	1.1%
6	1758	0.8%
7	1638	0.8%
8	1290	0.6%
9	1032	0.5%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	2	< 0.1%
1998	1	< 0.1%
1995	2	< 0.1%
1994	1	< 0.1%
1992	3	< 0.1%
1991	4	< 0.1%
1990	2	< 0.1%
1985	2	< 0.1%
1982	1	< 0.1%

days_first_active_acount_creation
Real number (ℝ)

SKEWED
ZEROS

Distinct	122
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.2097228088

Minimum	-1456
Maximum	0
Zeros	210574
Zeros (%)	99.9%
Negative	147
Negative (%)	0.1%
Memory size	1.6 MiB

Quantile statistics

Minimum	-1456
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.65651772
Coefficient of variation (CV)	-55.5805913
Kurtosis	6421.885233
Mean	-0.2097228088
Median Absolute Deviation (MAD)	0
Skewness	-74.02857652
Sum	-44193
Variance	135.8744055
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	210574	99.9%
-1	5	< 0.1%
-2	4	< 0.1%
-5	3	< 0.1%
-7	3	< 0.1%
-29	3	< 0.1%
-634	2	< 0.1%
-103	2	< 0.1%
-20	2	< 0.1%
-9	2	< 0.1%
Other values (112)	121	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1456	1	< 0.1%
-1369	1	< 0.1%
-1361	1	< 0.1%
-1148	1	< 0.1%
-1036	1	< 0.1%
-1018	1	< 0.1%
-1011	1	< 0.1%
-998	1	< 0.1%
-995	1	< 0.1%
-882	1	< 0.1%

Value	Count	Frequency (%)
0	210574	99.9%
-1	5	< 0.1%
-2	4	< 0.1%
-3	2	< 0.1%
-4	1	< 0.1%
-5	3	< 0.1%
-6	2	< 0.1%
-7	3	< 0.1%
-9	2	< 0.1%
-10	1	< 0.1%

days_first_active_first_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1969
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	431.4447018

Minimum	-1
Maximum	2292
Zeros	14516
Zeros (%)	6.9%
Negative	21062
Negative (%)	10.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	5
median	420
Q3	687
95-th percentile	1147
Maximum	2292
Range	2293
Interquartile range (IQR)	682

Descriptive statistics

Standard deviation	400.468811
Coefficient of variation (CV)	0.928204262
Kurtosis	-0.1154122352
Mean	431.4447018
Median Absolute Deviation (MAD)	380
Skewness	0.6758559145
Sum	90914459
Variance	160375.2686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	21062	10.0%
0	14516	6.9%
1	6394	3.0%
2	3952	1.9%
3	2888	1.4%
4	2221	1.1%
5	1755	0.8%
6	1637	0.8%
7	1288	0.6%
8	1032	0.5%
Other values (1959)	153976	73.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	21062	10.0%
0	14516	6.9%
1	6394	3.0%
2	3952	1.9%
3	2888	1.4%
4	2221	1.1%
5	1755	0.8%
6	1637	0.8%
7	1288	0.6%
8	1032	0.5%

Value	Count	Frequency (%)
2292	1	< 0.1%
2227	1	< 0.1%
2000	2	< 0.1%
1998	2	< 0.1%
1997	1	< 0.1%
1994	2	< 0.1%
1993	1	< 0.1%
1991	3	< 0.1%
1990	4	< 0.1%
1989	2	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	gender	age	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	date_first_booking_is_na	age_is_na	first_affiliate_tracked_is_na	first_booking_day_of_week	first_active_account_day_of_week	account_creation_day_of_week	first_booking_day	first_active_account_day	account_creation_day	first_booking_month	first_active_account_month	account_creation_month	first_booking_year	first_active_account_year	account_creation_year	first_booking_day_of_year	first_active_account_day_of_year	account_creation_day_of_year	first_booking_week_of_year	first_active_account_week_of_year	account_creation_week_of_year	days_account_creation_first_booking	days_first_active_acount_creation	days_first_active_first_booking
0	0	-unknown-	34	facebook	en	direct	direct	untracked	Web	Mac Desktop	Chrome	NDF	yes	no	no	0	3	0	29	19	28	6	3	6	2015	2009	2010	180	78	179	27	12	26	1827	-466	2292
1	1	MALE	38	facebook	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF	yes	no	no	0	5	2	29	23	25	6	5	5	2015	2009	2011	180	143	145	27	21	21	1496	-732	2227
2	3	FEMALE	42	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other	no	no	no	5	5	0	8	31	5	9	10	12	2012	2009	2011	252	304	339	36	44	49	278	-765	1042
3	5	-unknown-	34	basic	en	other	other	omg	Web	Mac Desktop	Chrome	US	no	no	no	5	4	4	2	1	1	1	1	1	2010	2010	2010	2	1	1	53	53	53	1	0	0
4	6	FEMALE	46	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	no	no	no	1	5	5	5	2	2	1	1	1	2010	2010	2010	5	2	2	1	53	53	3	0	2
5	7	FEMALE	47	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	US	no	no	no	2	6	6	13	3	3	1	1	1	2010	2010	2010	13	3	3	2	53	53	10	0	9
6	8	FEMALE	50	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	no	no	no	3	0	0	29	4	4	7	1	1	2010	2010	2010	210	4	4	30	1	1	206	0	205
7	9	-unknown-	46	basic	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US	no	no	no	0	0	0	4	4	4	1	1	1	2010	2010	2010	4	4	4	1	1	1	0	0	-1
8	10	FEMALE	36	basic	en	other	craigslist	untracked	Web	Mac Desktop	Firefox	US	no	no	no	2	0	0	6	4	4	1	1	1	2010	2010	2010	6	4	4	1	1	1	2	0	1
9	11	FEMALE	47	basic	en	other	craigslist	untracked	Web	iPhone	-unknown-	NDF	yes	no	no	0	1	1	29	5	5	6	1	1	2015	2010	2010	180	5	5	27	1	1	2001	0	2000

Last rows

	df_index	gender	age	signup_method	signup_flow	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	date_first_booking_is_na	age_is_na	first_affiliate_tracked_is_na	first_booking_day_of_week	first_booking_day	first_active_account_day	account_creation_day	first_booking_month	first_active_account_month	account_creation_month	first_booking_year	first_active_account_year	account_creation_year	first_booking_day_of_year	first_active_account_day_of_year	account_creation_day_of_year	first_booking_week_of_year	first_active_account_week_of_year	account_creation_week_of_year	days_account_creation_first_booking	days_first_active_first_booking
210711	213441	FEMALE	34	basic	0	en	direct	direct	linked	Web	Mac Desktop	Chrome	ES	no	no	no	2	13	30	30	8	6	6	2014	2014	2014	225	181	181	33	27	27	44	43
210712	213442	-unknown-	34	basic	0	en	sem-brand	google	omg	Web	Mac Desktop	Chrome	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210713	213443	FEMALE	36	basic	0	en	sem-brand	google	linked	Web	Mac Desktop	Safari	US	no	no	no	6	13	30	30	7	6	6	2014	2014	2014	194	181	181	28	27	27	13	12
210714	213444	-unknown-	34	basic	0	en	direct	direct	linked	Web	Windows Desktop	Chrome	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210715	213445	FEMALE	23	basic	0	en	sem-brand	google	omg	Web	Windows Desktop	IE	US	no	no	no	2	2	30	30	7	6	6	2014	2014	2014	183	181	181	27	27	27	2	1
210716	213446	MALE	32	basic	0	en	sem-brand	google	omg	Web	Mac Desktop	Safari	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210717	213447	-unknown-	34	basic	0	en	direct	direct	linked	Web	Windows Desktop	Chrome	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210718	213448	-unknown-	32	basic	0	en	direct	direct	untracked	Web	Mac Desktop	Firefox	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210719	213449	-unknown-	34	basic	25	en	other	other	tracked-other	iOS	iPhone	Mobile Safari	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363
210720	213450	-unknown-	34	basic	25	en	direct	direct	untracked	iOS	iPhone	-unknown-	NDF	yes	no	no	0	29	30	30	6	6	6	2015	2014	2014	180	181	181	27	27	27	364	363

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block